8b7911e0ecdfd873b71b9fe8f23c34b4739925d4,tests/frontend/org/voltdb/regressionsuites/TestSQLFeaturesNewSuite.java,TestSQLFeaturesNewSuite,testTableLimitAndPercentage,#,142

Before Change


        vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
        validateTableOfScalarLongs(vt, new long[] {0});

        verifyProcFails(client, "CONSTRAINT VIOLATION\\s*Table CAPPED0 exceeds table maximum row count 0",
                "CAPPED0.insert", 0, 0, 0);

        vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
        validateTableOfScalarLongs(vt, new long[] {0});

After Change



    public void testTableLimitAndPercentage() throws Exception {
        System.out.println("STARTING TABLE LIMIT AND PERCENTAGE FULL TEST......");
        Client client = getClient();
        VoltTable vt = null;
        Exception e = null;
        if(isHSQL()) {
            return;
        }

        // When table limit feature is fully supported, there needs to be more test cases.
        // generalize this test within a loop, maybe.
        // Test max row 0
        vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
        validateTableOfScalarLongs(vt, new long[] {0});

        e = null;
        try {
            vt = client.callProcedure("CAPPED0.insert", 0, 0, 0).getResults()[0];
        } catch (ProcCallException ex) {
            e = ex;
            assertTrue(ex.getMessage().contains("CONSTRAINT VIOLATION"));